import sqlalchemy as sa

from like.models.base import Base


class MedicalDiseaseClassificationIcd20(Base):
    """存储疾病分类国际临床版 2.0 相关信息的实体"""
    __tablename__ = 'medical_disease_classification_ICD_2_0'
    __table_args__ = {
        'mysql_engine': 'InnoDB',
        'mysql_charset': 'utf8mb4',
        'mysql_collate': 'utf8mb4_general_ci',
        'mysql_row_format': 'Dynamic',
        'comment': '存储疾病分类国际临床版 2.0 相关信息的表',
    }
    id = sa.Column(sa.Integer(), primary_key=True)  # 唯一标识该条记录的主键，自增整数
    name = sa.Column(sa.String())  # 用于存储疾病的名称，长度不超过 255 个字符
    code = sa.Column(sa.String())  # 用于存储疾病对应的编码，长度不超过 50 个字符
    create_time = sa.Column(sa.Integer())  # 
    update_time = sa.Column(sa.Integer())  # 
    delete_time = sa.Column(sa.Integer())  # 


medical_disease_classification_icd20 = MedicalDiseaseClassificationIcd20.__table__
